﻿CREATE TABLE [dbo].[Pick] (
    [PickID]      INT IDENTITY (1, 1) NOT NULL,
    [UserID]      INT NULL,
    [GameID]      INT NULL,
    [TeamID]      INT NULL,
    [TotalPoints] INT NULL,
    CONSTRAINT [PK_Pick] PRIMARY KEY CLUSTERED ([PickID] ASC),
    CONSTRAINT [FK_Pick_Game] FOREIGN KEY ([GameID]) REFERENCES [dbo].[Game] ([GameID]),
    CONSTRAINT [FK_Pick_Team] FOREIGN KEY ([TeamID]) REFERENCES [dbo].[Team] ([TeamID]),
    CONSTRAINT [FK_Pick_User] FOREIGN KEY ([UserID]) REFERENCES [dbo].[User] ([UserID])
);

